# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
tts by windows microsoft
excel reader by openpyxl
progreammer jyc
"""
import openpyxl,time
import win32com.client as wincl

ex = openpyxl.load_workbook(r"C:\Users\seewo\Desktop\七4班成绩登记册.xlsx")
ws = ex.active
for i in range(4,43):

    str1 = f"{ws.cell(row=i,column=3).value},总评 {ws.cell(row=i,column=68+3).value}"
    print(str1)
    speak = wincl.Dispatch("SAPI.SpVoice")
    speak.Speak(str1)
    time.sleep(2.5)